<html>

<head>
<title>Update</title>
<link type="text/css" href="jquery-ui-1.8.14.custom/css/ui-lightness/jquery-ui-1.8.14.custom.css" rel="Stylesheet" />	
<script type="text/javascript" src="jquery-1.6.2.min.js"></script>
<script type="text/javascript" src="jquery-ui-1.8.14.custom/js/jquery-ui-1.8.14.custom.min.js"></script>
</head>
<body>

<br/>
<br/>
<center><h1>Update SCHEDULE</h1></center>
<br/>
<center><table border=3 bordercolor="#ff99cc">
<tr><td>

<?
	$conn = oci_connect("hospital", "hospital", "//localhost/XE"); 
	$call = "select * from SCHEDULE where patient_id = '".$_GET["ids"]."' ";//??
	$col = $_GET["ids"];
	$pull = oci_parse($conn,$call);
	oci_execute($pull,OCI_DEFAULT);
	$total = oci_fetch_array($pull);
?>
<form action="edit-schedules.php?col=+<?echo $col?>" method="post">
	PATIENT_ID: <input type="text" name="pat" value = "<?=$total["PATIENT_ID"];?>" /><br/>
	SURGEON_ID: <input type="text" name="sur" value = "<?=$total["SURGEON_ID"];?>"/><br/>
	BED: <input type="text" name="bed" value = "<?=$total["BED"];?>"/><br/>
        REST TIME: <input type="text" name="time" value = "<?=$total["REST_TIME"];?>"/><br/>
                        
        <center><input type="submit" /></center>
	
</form>

</td></tr>
</table>


</body>
</html>